﻿using System.Collections.Generic;

namespace ExcelMapper
{
   public partial class ExcelDocument
    {
        public string Name { get; set; }
        public string PathFile { get; set; }
        public int RowHeader { get; set; }
        public int PreRowHeader { get; set; }
        public int SheetPage { get; set; }
        public string PrimaryKeyColumnName { get; set; }
        public string SecondaryKeyColumnName { get; set; }
        private List<IDictionary<string, object>> DocumentValues { get; set; }

        public ExcelDocument(string pathFile)
        {
            this.PathFile = pathFile;
            this.RowHeader = 1;
            this.PreRowHeader = 0;
            this.SheetPage = 1;
        }

        public ExcelDocument(string pathFile, int rowHeader, int preHeader)
        {
            this.PathFile = pathFile;
            this.RowHeader = rowHeader;
            this.PreRowHeader = preHeader;
            this.SheetPage = 1;
        }

        public ExcelDocument(string pathFile, int rowHeader, int preHeader, string name, int sheetPage = 1)
        {
            this.PathFile = pathFile;
            this.RowHeader = rowHeader;
            this.PreRowHeader = preHeader;
            this.Name = name;
            this.SheetPage = sheetPage;

        }

        public ExcelDocument(string pathFile, int rowHeader, int preHeader, string name, string primaryKeyColumnName, string SecondaryKeyColumnName, int sheetPage = 1)
        {
            this.PathFile = pathFile;
            this.RowHeader = rowHeader;
            this.PreRowHeader = preHeader;
            this.Name = name;
            this.SheetPage = sheetPage;
            this.PrimaryKeyColumnName = primaryKeyColumnName;
            this.SecondaryKeyColumnName = SecondaryKeyColumnName;

        }
    }
}
